This model dimension represents financial accounts and is based on the IFS Cloud dimension DIM_ACCOUNT. Most models that refer to this dimension will have the attributes and hierarchies as described below. One exception is the General Ledger model that also contains structure information related to:
Natural parent is company, i.e. each company has its on set of accounts.
| Attribute | Description (where applicable) |
| Company | Represents the natural parent COMPANY |
| Account Code | Represents the CODE of the dimension, i.e. account |
| Account | Built as CODE + ' - ' + DESCRIPTION |
| Account Desc | Represents the description of the Account |
| Account Group | Represents COMPANY + ' - ' + ACCOUNT_GROUP + ' - ' + ACCOUNT_GROUP_DESC |
| Account Group Code | Represents the account group code |
| Account Group Desc | Represents the account group description |
| Account Type | Represents the COMPANY + ' - ' + ACCOUT_TYPE + ' - ' + ACCOUNT_TYPE_DESC |
| Account Type Desc | Represents the account type description |
| Company - Account | Built as COMPANY + ' - ' CODE + ' - ' + DESCRIPTION |
| Statement Type | Represents Statement Type Description |
| Statement Type Code | Represents Statement Type Code |
| Account Type Code | Represents the account type code |
| Bs Structure ID | Identity of the Balance Sheet structure |
| Bs Value Description | Name of a node or a leaf in the Balance Sheet structure |
| Is Structure ID | Income Statement structure |
| Is Value Description | Name of a node or a leaf in the Income Statement structure |
| Hierarchy | Level |
| BsHy | |
| BSL10 | |
| BSL09 | |
| BSL08 | |
| BSL07 | |
| BSL06 | |
| BSL05 | |
| BSL04 | |
| BSL03 | |
| BSL02 | |
| BSL01 | |
| IsHy | |
| ISL10 | |
| ISL09 | |
| ISL08 | |
| ISL07 | |
| ISL06 | |
| ISL05 | |
| ISL04 | |
| ISL03 | |
| ISL02 | |
| ISL01 |
| Model Name |
| General Ledger |
The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| ACCOUNT | DIM_ACCOUNT_FINANCIALS_TM | DIM_ACCOUNT_BI | DIM_ACCOUNT | On Line |